Tabela PhDrugDDDhist

Definicja tabeli PhDrugDDDhist

Name

PhDrugDDDhist

Code

PhDrugDDDhist

Comment

tabela ze Zdefiniowanymi Dziennymi Dawkami (defined daily dose)


Lista kolumn tabeli PhDrugDDDhist

Name

Code

DrugDDDID

DrugDDDID

StockItemID

StockItemID

DailyUsageQuantity

DailyUsageQuantity

DailyUsageUnitID

DailyUsageUnitID

SummaryUsageQuantity

SummaryUsageQuantity

SummaryUsageUnitID

SummaryUsageUnitID

TimeOfUsageQuantity

TimeOfUsageQuantity

TimeOfUsageUnitID

TimeOfUsageUnitID

AgeQuantity

AgeQuantity

AgeUnitID

AgeUnitID

Weight

Weight

BodySurface

BodySurface

rev

rev

RevTypeId

RevTypeId


Kolumna DrugDDDID tabeli PhDrugDDDhist

Definicja kolumny DrugDDDID tabeli PhDrugDDDhist

Name

DrugDDDID

Code

DrugDDDID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

klucz glówny


Kolumna StockItemID tabeli PhDrugDDDhist

Definicja kolumny StockItemID tabeli PhDrugDDDhist

Name

StockItemID

Code

StockItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

id asortymentu


Kolumna DailyUsageQuantity tabeli PhDrugDDDhist

Definicja kolumny DailyUsageQuantity tabeli PhDrugDDDhist

Name

DailyUsageQuantity

Code

DailyUsageQuantity

Data Type

NUMBER(19,8)

Mandatory

No

Comment

dzienna dawka (ilosc)


Kolumna DailyUsageUnitID tabeli PhDrugDDDhist

Definicja kolumny DailyUsageUnitID tabeli PhDrugDDDhist

Name

DailyUsageUnitID

Code

DailyUsageUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

dzienna dawka (jednostka)


Kolumna SummaryUsageQuantity tabeli PhDrugDDDhist

Definicja kolumny SummaryUsageQuantity tabeli PhDrugDDDhist

Name

SummaryUsageQuantity

Code

SummaryUsageQuantity

Data Type

NUMBER(19,8)

Mandatory

No

Comment

sumaryczna dawka (ilosc)


Kolumna SummaryUsageUnitID tabeli PhDrugDDDhist

Definicja kolumny SummaryUsageUnitID tabeli PhDrugDDDhist

Name

SummaryUsageUnitID

Code

SummaryUsageUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

sumaryczna dawka (jednostka)


Kolumna TimeOfUsageQuantity tabeli PhDrugDDDhist

Definicja kolumny TimeOfUsageQuantity tabeli PhDrugDDDhist

Name

TimeOfUsageQuantity

Code

TimeOfUsageQuantity

Data Type

NUMBER(10)

Mandatory

No

Comment

maksymalny czas podawania (ilosc)


Kolumna TimeOfUsageUnitID tabeli PhDrugDDDhist

Definicja kolumny TimeOfUsageUnitID tabeli PhDrugDDDhist

Name

TimeOfUsageUnitID

Code

TimeOfUsageUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

maksymalny czas podawania (jednostka)


Kolumna AgeQuantity tabeli PhDrugDDDhist

Definicja kolumny AgeQuantity tabeli PhDrugDDDhist

Name

AgeQuantity

Code

AgeQuantity

Data Type

NUMBER(10)

Mandatory

No

Comment

wiek pacjenta


Kolumna AgeUnitID tabeli PhDrugDDDhist

Definicja kolumny AgeUnitID tabeli PhDrugDDDhist

Name

AgeUnitID

Code

AgeUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

wiek pacjenta (jednostka)


Kolumna Weight tabeli PhDrugDDDhist

Definicja kolumny Weight tabeli PhDrugDDDhist

Name

Weight

Code

Weight

Data Type

NUMBER(19,8)

Mandatory

No

Comment

waga pacjenta


Kolumna BodySurface tabeli PhDrugDDDhist

Definicja kolumny BodySurface tabeli PhDrugDDDhist

Name

BodySurface

Code

BodySurface

Data Type

NUMBER(19,8)

Mandatory

No

Comment

powierzchnia ciala


Kolumna rev tabeli PhDrugDDDhist

Definicja kolumny rev tabeli PhDrugDDDhist

Name

rev

Code

rev

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RevTypeId tabeli PhDrugDDDhist

Definicja kolumny RevTypeId tabeli PhDrugDDDhist

Name

RevTypeId

Code

RevTypeId

Data Type

NUMBER(5)

Mandatory

No

Comment